5260221af67826a5848111dadafd1ebdc86aa01e,server/zanata-war/src/main/java/org/zanata/dao/ProjectDAO.java,ProjectDAO,getFilterProjectSize,#boolean#boolean#boolean#,54

Before Change


   public int getFilterProjectSize(boolean filterActive, boolean filterReadOnly, boolean filterObsolete)
   {
      String query = "select count(*) from HProject p " + constructFilterCondition(filterActive, filterReadOnly, filterObsolete);
      Long totalCount = (Long) getSession().createQuery(query.toString()).uniqueResult();

      if (totalCount == null)
         return 0;

After Change


   public int getFilterProjectSize(boolean filterActive, boolean filterReadOnly, boolean filterObsolete)
   {
      String query = "select count(*) from HProject p " + constructFilterCondition(filterActive, filterReadOnly, filterObsolete);
      Query q = getSession().createQuery(query.toString());
      q.setCacheable(true).setComment("ProjectDAO.getFilterProjectSize");
      Long totalCount = (Long) q.uniqueResult();

      if (totalCount == null)
         return 0;